# -*- coding: utf-8 -*-
"""
Created on Wed Sep 22 08:10:04 2021

@author: rklotz
"""

import pandas as pd

new_file = r"H:\My Drive\Boats\ReplicationCode\data\final_test\CA_tracks.csv"
#old_file = r"H:\My Drive\Boats\ReplicationCode\data\final\CA_tracks_v2a.csv"
old_file = r"H:/My Drive/Boats/Stata/CA_tracks/CA_tracks_wAP2_04082020_v2a.csv"

df_new = pd.read_csv(new_file)
df_old = pd.read_csv(old_file)

vars_to_check = ['AISyear','OID','DIST','DIST_ECA2009','TD_NOx_cons_200km','Operator','stroke','port_name2_ECport']

df_cmp = df_old[vars_to_check].merge(df_new[vars_to_check],on=['AISyear','OID'])